Supplier / Product / Warehouse Cross Reference Table
The Item File allows for entry of a Usual Supplier which is used in the following applications:
- Auto-Generation of Purchase Orders
- Some reports, when the Usual Supplier field is selected as a sort.
When material is ordered, depending upon the warehouse that is ordering, the Usual Supplier may NOT be the correct supplier for that warehouse to order from. On manually written PO's this is not a problem - because the user inputs the appropriate supplier on the PO header. However, the Auto-PO-Generation process relies on the Usual Supplier field.
The Supplier/Product/Warehouse Cross Reference table enables the Auto-Generation Of Purchase Orders program to select the correct supplier, based upon the ordering warehouse.
This table can handle the following purchasing scenarios:
- Branches of your business ordering the same product from different suppliers, based upon geograÂphy. For example, branch NYC orders product 123 from supplier ABC, but branch LOS orders product 123 from supplier XYZ.
- Branches of your business ordering the same product from different branches of the same supÂplier, based upon geography. For example, branch NYC orders product 456 from supplier AB1, while branch LOS orders the same product from supplier AB2.
To create a new record, click Records and then select Create. The Create Record window appears.
| Field | Description |
| Manufacturer | The manufacturer of the items being ordered. |
| Product Line | The product line will normally be *** for all, but it could be used in situations where one or more product lines need to be routed to a special supplier code. |
| Warehouse | The warehouse that is ordering the material. |
| Supplier | This entry represents the plant or third party where the product originates from. *** represents the usual supplier as defined in the Item File. |
Creating a New Table
- To create a new table, select Create under the Records heading.
- Enter the manufacturer, product line, warehouse, and the supplier to order from. Keep in mind that by entering *** in the Product Line and Warehouse fields, you are selecting all the product lines, all the warehouses. However, *** in the Supplier field signifies that you want to use the usual supplier as designated in the Item File.
Associated Files
Expected Supplier Rebate Table - SET 10